﻿<?xml version="1.0" encoding="utf-8" ?> 
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		UPDATE ObjectTreeCounts SET
			treeName = SUBSTRING(treeName, 8,1000)
		FROM ObjectTreeCounts
			INNER JOIN  ObjectTreeNodes ON ObjectTreeCounts.objectId = ObjectTreeNodes.objectId
		WHERE
			treeName = @deletedTreeName and
			(ObjectTreeNodes.parentHostId = @id)
	</Sql>
	<Param name="id" type="UniqueIdentifier" />
	<Param name="deletedTreeName" type="String" />
</AdoNetDataAccess>
